package com.example.springback.mapper;

import com.example.springback.domain.Enterprise;
import com.example.springback.domain.Pension ;

import java.util.List;
import java.util.Map;

/**
* @author lenovo
* @description 针对表【pension】的数据库操作Mapper
* @createDate 2025-04-14 15:43:47
* @Entity generator.domain.Pension
*/
public interface PensionMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Pension record);

    int insertSelective(Pension record);

    Pension selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Pension record);

    int updateByPrimaryKey(Pension record);

    List<Enterprise> selectAll(String enterpriseName);

    List<Pension> selectEnterprise(Pension pension);

    int selectTodayPayNum(String pensionTime);

    Pension selectByEnterpriseAndTerm(Pension pension);

    List<Map<String, Object>> getMonthlyTrend(int months);

    List<Map<String, Object>> selectMonthlyPensionByEnterprise(String month);

    double sumAllPension(String month);
}
